Pandas Profiling Report

Dataset statistics

Number of variables	22
Number of observations	62554
Missing cells	164374
Missing cells (%)	11.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	10.1 MiB
Average record size in memory	169.0 B

Variable types

Categorical	13
Numeric	8
Boolean	1

Alerts

`year` has constant value "2020"	Constant
`dt_kst` has a high cardinality: 39340 distinct values	High cardinality
`actionOption` is highly overall correlated with `action` and 3 other fields	High correlation
`actionSubOption` is highly overall correlated with `action` and 3 other fields	High correlation
`emotionPositive` is highly overall correlated with `user_id`	High correlation
`emotionTension` is highly overall correlated with `user_id`	High correlation
`activity` is highly overall correlated with `actionSub`	High correlation
`day` is highly overall correlated with `date_ymd` and 2 other fields	High correlation
`day_of_week` is highly overall correlated with `date_ymd` and 2 other fields	High correlation
`hour` is highly overall correlated with `actionSub` and 1 other fields	High correlation
`action` is highly overall correlated with `actionOption` and 5 other fields	High correlation
`actionSub` is highly overall correlated with `actionOption` and 6 other fields	High correlation
`condition` is highly overall correlated with `actionOption` and 4 other fields	High correlation
`conditionSub1Option` is highly overall correlated with `action` and 4 other fields	High correlation
`conditionSub2Option` is highly overall correlated with `actionSubOption` and 1 other fields	High correlation
`place` is highly overall correlated with `actionOption` and 4 other fields	High correlation
`date_ymd` is highly overall correlated with `day` and 5 other fields	High correlation
`month` is highly overall correlated with `day` and 1 other fields	High correlation
`day_name` is highly overall correlated with `day_of_week` and 2 other fields	High correlation
`meridiem` is highly overall correlated with `hour`	High correlation
`is_weekend` is highly overall correlated with `day` and 4 other fields	High correlation
`user_id` is highly overall correlated with `actionSubOption` and 3 other fields	High correlation
`month` is highly imbalanced (72.6%)	Imbalance
`actionSub` has 47876 (76.5%) missing values	Missing
`actionSubOption` has 47876 (76.5%) missing values	Missing
`conditionSub1Option` has 34311 (54.9%) missing values	Missing
`conditionSub2Option` has 34311 (54.9%) missing values	Missing
`dt_kst` is uniformly distributed	Uniform
`activity` has 3050 (4.9%) zeros	Zeros
`day_of_week` has 8712 (13.9%) zeros	Zeros
`hour` has 1368 (2.2%) zeros	Zeros

Reproduction

Analysis started	2023-03-28 11:05:41.462833
Analysis finished	2023-03-28 11:05:54.864032
Duration	13.4 seconds
Software version	pandas-profiling v0.0.dev0
Download configuration	config.json

action
Categorical

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	488.8 KiB

sleep	14722
work	13770
recreation_media	9327
travel	8455
meal	6223
Other values (8)	10057

Length

Max length	16
Median length	14
Mean length	7.599562
Min length	4

Characters and Unicode

Total characters	475383
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	sleep
2nd row	sleep
3rd row	sleep
4th row	sleep
5th row	sleep

Common Values

Value	Count	Frequency (%)
sleep	14722	23.5%
work	13770	22.0%
recreation_media	9327	14.9%
travel	8455	13.5%
meal	6223	9.9%
recreation_etc	3552	5.7%
personal_care	3221	5.1%
household	848	1.4%
shop	762	1.2%
socialising	720	1.2%
Other values (3)	954	1.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sleep	14722	23.5%
work	13770	22.0%
recreation_media	9327	14.9%
travel	8455	13.5%
meal	6223	9.9%
recreation_etc	3552	5.7%
personal_care	3221	5.1%
household	848	1.4%
shop	762	1.2%
socialising	720	1.2%
Other values (3)	954	1.5%

Most occurring characters

Value	Count	Frequency (%)
e	92035	19.4%
r	55349	11.6%
a	44970	9.5%
l	34189	7.2%
o	33864	7.1%
t	27396	5.8%
i	25028	5.3%
s	20993	4.4%
c	20634	4.3%
n	18806	4.0%
Other values (12)	102119	21.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	459021	96.6%
Connector Punctuation	16362	3.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	92035	20.1%
r	55349	12.1%
a	44970	9.8%
l	34189	7.4%
o	33864	7.4%
t	27396	6.0%
i	25028	5.5%
s	20993	4.6%
c	20634	4.5%
n	18806	4.1%
Other values (11)	85757	18.7%

Connector Punctuation

Value	Count	Frequency (%)
_	16362	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	459021	96.6%
Common	16362	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	92035	20.1%
r	55349	12.1%
a	44970	9.8%
l	34189	7.4%
o	33864	7.4%
t	27396	6.0%
i	25028	5.5%
s	20993	4.6%
c	20634	4.5%
n	18806	4.1%
Other values (11)	85757	18.7%

Common

Value	Count	Frequency (%)
_	16362	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	475383	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	92035	19.4%
r	55349	11.6%
a	44970	9.5%
l	34189	7.2%
o	33864	7.1%
t	27396	5.8%
i	25028	5.3%
s	20993	4.4%
c	20634	4.3%
n	18806	4.0%
Other values (12)	102119	21.5%

actionOption
Real number (ℝ)

Distinct	33
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	276.75506

Minimum	41
Maximum	793
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	488.8 KiB

Quantile statistics

Minimum	41
5-th percentile	82
Q1	111
median	132
Q3	211
95-th percentile	793
Maximum	793
Range	752
Interquartile range (IQR)	100

Descriptive statistics

Standard deviation	259.77467
Coefficient of variation (CV)	0.93864469
Kurtosis	-0.45239509
Mean	276.75506
Median Absolute Deviation (MAD)	50
Skewness	1.1798849
Sum	17312136
Variance	67482.877
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
111	14491	23.2%
211	13533	21.6%
722	5652	9.0%
82	5625	9.0%
121	5538	8.9%
793	3250	5.2%
132	2258	3.6%
724	1899	3.0%
725	1628	2.6%
87	1462	2.3%
Other values (23)	7218	11.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41	40	0.1%
43	134	0.2%
45	290	0.5%
46	384	0.6%
81	1145	1.8%
82	5625	9.0%
84	223	0.4%
87	1462	2.3%
91	58	0.1%
92	704	1.1%

Value	Count	Frequency (%)
793	3250	5.2%
791	302	0.5%
761	30	< 0.1%
756	2	< 0.1%
751	260	0.4%
746	502	0.8%
742	160	0.3%
725	1628	2.6%
724	1899	3.0%
722	5652	9.0%

actionSub
Categorical

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	47876
Missing (%)	76.5%
Memory size	488.8 KiB

move_method	8455
meal_amount	6223

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	161458
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	meal_amount
2nd row	meal_amount
3rd row	meal_amount
4th row	meal_amount
5th row	meal_amount

Common Values

Value	Count	Frequency (%)
move_method	8455	13.5%
meal_amount	6223	9.9%
(Missing)	47876	76.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
move_method	8455	57.6%
meal_amount	6223	42.4%

Most occurring characters

Value	Count	Frequency (%)
m	29356	18.2%
o	23133	14.3%
e	23133	14.3%
_	14678	9.1%
t	14678	9.1%
a	12446	7.7%
v	8455	5.2%
h	8455	5.2%
d	8455	5.2%
l	6223	3.9%
Other values (2)	12446	7.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	146780	90.9%
Connector Punctuation	14678	9.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
m	29356	20.0%
o	23133	15.8%
e	23133	15.8%
t	14678	10.0%
a	12446	8.5%
v	8455	5.8%
h	8455	5.8%
d	8455	5.8%
l	6223	4.2%
u	6223	4.2%

Connector Punctuation

Value	Count	Frequency (%)
_	14678	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	146780	90.9%
Common	14678	9.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
m	29356	20.0%
o	23133	15.8%
e	23133	15.8%
t	14678	10.0%
a	12446	8.5%
v	8455	5.8%
h	8455	5.8%
d	8455	5.8%
l	6223	4.2%
u	6223	4.2%

Common

Value	Count	Frequency (%)
_	14678	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	161458	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
m	29356	18.2%
o	23133	14.3%
e	23133	14.3%
_	14678	9.1%
t	14678	9.1%
a	12446	7.7%
v	8455	5.2%
h	8455	5.2%
d	8455	5.2%
l	6223	3.9%
Other values (2)	12446	7.7%

actionSubOption
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	47876
Missing (%)	76.5%
Infinite	0
Infinite (%)	0.0%
Mean	3.2885952

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	488.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	6
95-th percentile	6
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.9945677
Coefficient of variation (CV)	0.60651054
Kurtosis	-1.5053757
Mean	3.2885952
Median Absolute Deviation (MAD)	2
Skewness	0.35005424
Sum	48270
Variance	3.9783001
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
6	4170	6.7%
1	3507	5.6%
2	3418	5.5%
3	2544	4.1%
5	999	1.6%
7	40	0.1%
(Missing)	47876	76.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3507	5.6%
2	3418	5.5%
3	2544	4.1%
5	999	1.6%
6	4170	6.7%
7	40	0.1%

Value	Count	Frequency (%)
7	40	0.1%
6	4170	6.7%
5	999	1.6%
3	2544	4.1%
2	3418	5.5%
1	3507	5.6%

condition
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	488.8 KiB

ALONE	34450
WITH_MANY	15888
WITH_ONE	12216

Length

Max length	9
Median length	5
Mean length	6.601816
Min length	5

Characters and Unicode

Total characters	412970
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WITH_ONE
2nd row	WITH_ONE
3rd row	WITH_ONE
4th row	WITH_ONE
5th row	WITH_ONE

Common Values

Value	Count	Frequency (%)
ALONE	34450	55.1%
WITH_MANY	15888	25.4%
WITH_ONE	12216	19.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
alone	34450	55.1%
with_many	15888	25.4%
with_one	12216	19.5%

Most occurring characters

Value	Count	Frequency (%)
N	62554	15.1%
A	50338	12.2%
O	46666	11.3%
E	46666	11.3%
L	34450	8.3%
W	28104	6.8%
I	28104	6.8%
T	28104	6.8%
H	28104	6.8%
_	28104	6.8%
Other values (2)	31776	7.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	384866	93.2%
Connector Punctuation	28104	6.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	62554	16.3%
A	50338	13.1%
O	46666	12.1%
E	46666	12.1%
L	34450	9.0%
W	28104	7.3%
I	28104	7.3%
T	28104	7.3%
H	28104	7.3%
M	15888	4.1%

Connector Punctuation

Value	Count	Frequency (%)
_	28104	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	384866	93.2%
Common	28104	6.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	62554	16.3%
A	50338	13.1%
O	46666	12.1%
E	46666	12.1%
L	34450	9.0%
W	28104	7.3%
I	28104	7.3%
T	28104	7.3%
H	28104	7.3%
M	15888	4.1%

Common

Value	Count	Frequency (%)
_	28104	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	412970	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	62554	15.1%
A	50338	12.2%
O	46666	11.3%
E	46666	11.3%
L	34450	8.3%
W	28104	6.8%
I	28104	6.8%
T	28104	6.8%
H	28104	6.8%
_	28104	6.8%
Other values (2)	31776	7.7%

conditionSub1Option
Categorical

HIGH CORRELATION MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	34311
Missing (%)	54.9%
Memory size	488.8 KiB

3.0	14984
2.0	10110
1.0	2706
5.0	300
4.0	143

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	84729
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.0
2nd row	2.0
3rd row	2.0
4th row	2.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
3.0	14984	24.0%
2.0	10110	16.2%
1.0	2706	4.3%
5.0	300	0.5%
4.0	143	0.2%
(Missing)	34311	54.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3.0	14984	53.1%
2.0	10110	35.8%
1.0	2706	9.6%
5.0	300	1.1%
4.0	143	0.5%

Most occurring characters

Value	Count	Frequency (%)
.	28243	33.3%
0	28243	33.3%
3	14984	17.7%
2	10110	11.9%
1	2706	3.2%
5	300	0.4%
4	143	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	56486	66.7%
Other Punctuation	28243	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	28243	50.0%
3	14984	26.5%
2	10110	17.9%
1	2706	4.8%
5	300	0.5%
4	143	0.3%

Other Punctuation

Value	Count	Frequency (%)
.	28243	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	84729	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	28243	33.3%
0	28243	33.3%
3	14984	17.7%
2	10110	11.9%
1	2706	3.2%
5	300	0.4%
4	143	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84729	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	28243	33.3%
0	28243	33.3%
3	14984	17.7%
2	10110	11.9%
1	2706	3.2%
5	300	0.4%
4	143	0.2%

conditionSub2Option
Categorical

HIGH CORRELATION MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	34311
Missing (%)	54.9%
Memory size	488.8 KiB

1.0	17100
2.0	8526
3.0	2617

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	84729
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	17100	27.3%
2.0	8526	13.6%
3.0	2617	4.2%
(Missing)	34311	54.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	17100	60.5%
2.0	8526	30.2%
3.0	2617	9.3%

Most occurring characters

Value	Count	Frequency (%)
.	28243	33.3%
0	28243	33.3%
1	17100	20.2%
2	8526	10.1%
3	2617	3.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	56486	66.7%
Other Punctuation	28243	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	28243	50.0%
1	17100	30.3%
2	8526	15.1%
3	2617	4.6%

Other Punctuation

Value	Count	Frequency (%)
.	28243	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	84729	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	28243	33.3%
0	28243	33.3%
1	17100	20.2%
2	8526	10.1%
3	2617	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84729	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	28243	33.3%
0	28243	33.3%
1	17100	20.2%
2	8526	10.1%
3	2617	3.1%

place
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	488.8 KiB

home	27500
workplace	14749
outdoor	10228
other_indoor	7795
restaurant	2282

Length

Max length	12
Median length	10
Mean length	6.8852032
Min length	4

Characters and Unicode

Total characters	430697
Distinct characters	18
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	other_indoor
2nd row	other_indoor
3rd row	other_indoor
4th row	other_indoor
5th row	other_indoor

Common Values

Value	Count	Frequency (%)
home	27500	44.0%
workplace	14749	23.6%
outdoor	10228	16.4%
other_indoor	7795	12.5%
restaurant	2282	3.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
home	27500	44.0%
workplace	14749	23.6%
outdoor	10228	16.4%
other_indoor	7795	12.5%
restaurant	2282	3.6%

Most occurring characters

Value	Count	Frequency (%)
o	96318	22.4%
e	52326	12.1%
r	45131	10.5%
h	35295	8.2%
m	27500	6.4%
t	22587	5.2%
a	19313	4.5%
d	18023	4.2%
p	14749	3.4%
l	14749	3.4%
Other values (8)	84706	19.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	422902	98.2%
Connector Punctuation	7795	1.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	96318	22.8%
e	52326	12.4%
r	45131	10.7%
h	35295	8.3%
m	27500	6.5%
t	22587	5.3%
a	19313	4.6%
d	18023	4.3%
p	14749	3.5%
l	14749	3.5%
Other values (7)	76911	18.2%

Connector Punctuation

Value	Count	Frequency (%)
_	7795	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	422902	98.2%
Common	7795	1.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	96318	22.8%
e	52326	12.4%
r	45131	10.7%
h	35295	8.3%
m	27500	6.5%
t	22587	5.3%
a	19313	4.6%
d	18023	4.3%
p	14749	3.5%
l	14749	3.5%
Other values (7)	76911	18.2%

Common

Value	Count	Frequency (%)
_	7795	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	430697	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	96318	22.4%
e	52326	12.1%
r	45131	10.5%
h	35295	8.2%
m	27500	6.4%
t	22587	5.2%
a	19313	4.5%
d	18023	4.2%
p	14749	3.4%
l	14749	3.4%
Other values (8)	84706	19.7%

emotionPositive
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.9777792

Minimum	2
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	488.8 KiB

Quantile statistics

Minimum	2
5-th percentile	4
Q1	4
median	5
Q3	5
95-th percentile	7
Maximum	7
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.90969229
Coefficient of variation (CV)	0.18275063
Kurtosis	0.43750453
Mean	4.9777792
Median Absolute Deviation (MAD)	0
Skewness	0.34410448
Sum	311380
Variance	0.82754006
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
5	33769	54.0%
4	13786	22.0%
6	7417	11.9%
7	5049	8.1%
3	2480	4.0%
2	53	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	53	0.1%
3	2480	4.0%
4	13786	22.0%
5	33769	54.0%
6	7417	11.9%
7	5049	8.1%

Value	Count	Frequency (%)
7	5049	8.1%
6	7417	11.9%
5	33769	54.0%
4	13786	22.0%
3	2480	4.0%
2	53	0.1%

emotionTension
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0129168

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	488.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	4
Maximum	6
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.94734996
Coefficient of variation (CV)	0.47063542
Kurtosis	0.93237052
Mean	2.0129168
Median Absolute Deviation (MAD)	1
Skewness	1.0693149
Sum	125916
Variance	0.89747195
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2	30999	49.6%
1	19107	30.5%
3	6033	9.6%
4	5408	8.6%
5	962	1.5%
6	45	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	19107	30.5%
2	30999	49.6%
3	6033	9.6%
4	5408	8.6%
5	962	1.5%
6	45	0.1%

Value	Count	Frequency (%)
6	45	0.1%
5	962	1.5%
4	5408	8.6%
3	6033	9.6%
2	30999	49.6%
1	19107	30.5%

activity
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.9145378

Minimum	0
Maximum	6
Zeros	3050
Zeros (%)	4.9%
Negative	0
Negative (%)	0.0%
Memory size	488.8 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	3
Q3	3
95-th percentile	4
Maximum	6
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.75680131
Coefficient of variation (CV)	0.25966426
Kurtosis	8.349256
Mean	2.9145378
Median Absolute Deviation (MAD)	0
Skewness	-2.5428023
Sum	182316
Variance	0.57274822
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
3	50961	81.5%
4	6142	9.8%
0	3050	4.9%
2	2344	3.7%
1	33	0.1%
6	24	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3050	4.9%
1	33	0.1%
2	2344	3.7%
3	50961	81.5%
4	6142	9.8%
6	24	< 0.1%

Value	Count	Frequency (%)
6	24	< 0.1%
4	6142	9.8%
3	50961	81.5%
2	2344	3.7%
1	33	0.1%
0	3050	4.9%

dt_kst
Categorical

HIGH CARDINALITY UNIFORM

Distinct	39340
Distinct (%)	62.9%
Missing	0
Missing (%)	0.0%
Memory size	488.8 KiB

2020-09-03 13:25:00+09:00	4
2020-09-02 13:30:00+09:00	4
2020-09-20 21:19:00+09:00	3
2020-09-03 09:17:00+09:00	3
2020-09-20 18:14:00+09:00	3
Other values (39335)	62537

Length

Max length	25
Median length	25
Mean length	25
Min length	25

Characters and Unicode

Total characters	1563850
Distinct characters	14
Distinct categories	5 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16311 ?
Unique (%)	26.1%

Sample

1st row	2020-08-30 00:00:00+09:00
2nd row	2020-08-30 00:01:00+09:00
3rd row	2020-08-30 00:02:00+09:00
4th row	2020-08-30 00:03:00+09:00
5th row	2020-08-30 00:04:00+09:00

Common Values

Value	Count	Frequency (%)
2020-09-03 13:25:00+09:00	4	< 0.1%
2020-09-02 13:30:00+09:00	4	< 0.1%
2020-09-20 21:19:00+09:00	3	< 0.1%
2020-09-03 09:17:00+09:00	3	< 0.1%
2020-09-20 18:14:00+09:00	3	< 0.1%
2020-09-16 12:40:00+09:00	3	< 0.1%
2020-09-14 17:40:00+09:00	3	< 0.1%
2020-09-25 11:33:00+09:00	3	< 0.1%
2020-09-20 18:07:00+09:00	3	< 0.1%
2020-09-16 09:10:00+09:00	3	< 0.1%
Other values (39330)	62522	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-09-17	2451	2.0%
2020-09-15	2451	2.0%
2020-09-09	2414	1.9%
2020-09-24	2389	1.9%
2020-09-22	2384	1.9%
2020-09-14	2380	1.9%
2020-09-10	2367	1.9%
2020-09-07	2364	1.9%
2020-09-11	2353	1.9%
2020-09-02	2333	1.9%
Other values (1459)	101222	80.9%

Most occurring characters

Value	Count	Frequency (%)
0	569028	36.4%
:	187662	12.0%
2	185138	11.8%
9	139292	8.9%
-	125108	8.0%
1	87092	5.6%
	62554	4.0%
+	62554	4.0%
3	33040	2.1%
5	28194	1.8%
Other values (4)	84188	5.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1125972	72.0%
Other Punctuation	187662	12.0%
Dash Punctuation	125108	8.0%
Space Separator	62554	4.0%
Math Symbol	62554	4.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	569028	50.5%
2	185138	16.4%
9	139292	12.4%
1	87092	7.7%
3	33040	2.9%
5	28194	2.5%
4	28128	2.5%
8	19692	1.7%
7	18828	1.7%
6	17540	1.6%

Other Punctuation

Value	Count	Frequency (%)
:	187662	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	125108	100.0%

Space Separator

Value	Count	Frequency (%)
	62554	100.0%

Math Symbol

Value	Count	Frequency (%)
+	62554	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1563850	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	569028	36.4%
:	187662	12.0%
2	185138	11.8%
9	139292	8.9%
-	125108	8.0%
1	87092	5.6%
	62554	4.0%
+	62554	4.0%
3	33040	2.1%
5	28194	1.8%
Other values (4)	84188	5.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1563850	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	569028	36.4%
:	187662	12.0%
2	185138	11.8%
9	139292	8.9%
-	125108	8.0%
1	87092	5.6%
	62554	4.0%
+	62554	4.0%
3	33040	2.1%
5	28194	1.8%
Other values (4)	84188	5.4%

date_ymd
Categorical

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	488.8 KiB

2020-09-15	2451
2020-09-17	2451
2020-09-09	2414
2020-09-24	2389
2020-09-22	2384
Other values (24)	50465

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	625540
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2020-08-30
2nd row	2020-08-30
3rd row	2020-08-30
4th row	2020-08-30
5th row	2020-08-30

Common Values

Value	Count	Frequency (%)
2020-09-15	2451	3.9%
2020-09-17	2451	3.9%
2020-09-09	2414	3.9%
2020-09-24	2389	3.8%
2020-09-22	2384	3.8%
2020-09-14	2380	3.8%
2020-09-10	2367	3.8%
2020-09-07	2364	3.8%
2020-09-11	2353	3.8%
2020-09-02	2333	3.7%
Other values (19)	38668	61.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-09-15	2451	3.9%
2020-09-17	2451	3.9%
2020-09-09	2414	3.9%
2020-09-24	2389	3.8%
2020-09-22	2384	3.8%
2020-09-14	2380	3.8%
2020-09-10	2367	3.8%
2020-09-07	2364	3.8%
2020-09-11	2353	3.8%
2020-09-02	2333	3.7%
Other values (19)	38668	61.8%

Most occurring characters

Value	Count	Frequency (%)
0	212448	34.0%
2	149836	24.0%
-	125108	20.0%
9	64224	10.3%
1	30774	4.9%
3	9195	1.5%
8	7181	1.1%
7	6968	1.1%
5	6832	1.1%
4	6643	1.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	500432	80.0%
Dash Punctuation	125108	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	212448	42.5%
2	149836	29.9%
9	64224	12.8%
1	30774	6.1%
3	9195	1.8%
8	7181	1.4%
7	6968	1.4%
5	6832	1.4%
4	6643	1.3%
6	6331	1.3%

Dash Punctuation

Value	Count	Frequency (%)
-	125108	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	625540	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	212448	34.0%
2	149836	24.0%
-	125108	20.0%
9	64224	10.3%
1	30774	4.9%
3	9195	1.5%
8	7181	1.1%
7	6968	1.1%
5	6832	1.1%
4	6643	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	625540	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	212448	34.0%
2	149836	24.0%
-	125108	20.0%
9	64224	10.3%
1	30774	4.9%
3	9195	1.5%
8	7181	1.1%
7	6968	1.1%
5	6832	1.1%
4	6643	1.1%

year
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	488.8 KiB

2020	62554

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	250216
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2020
2nd row	2020
3rd row	2020
4th row	2020
5th row	2020

Common Values

Value	Count	Frequency (%)
2020	62554	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2020	62554	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	125108	50.0%
0	125108	50.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	250216	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	125108	50.0%
0	125108	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	250216	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	125108	50.0%
0	125108	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	250216	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	125108	50.0%
0	125108	50.0%

month
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	488.8 KiB

9	59607
8	2947

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	62554
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	8
2nd row	8
3rd row	8
4th row	8
5th row	8

Common Values

Value	Count	Frequency (%)
9	59607	95.3%
8	2947	4.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
9	59607	95.3%
8	2947	4.7%

Most occurring characters

Value	Count	Frequency (%)
9	59607	95.3%
8	2947	4.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	62554	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	59607	95.3%
8	2947	4.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	62554	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
9	59607	95.3%
8	2947	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	62554	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
9	59607	95.3%
8	2947	4.7%

day
Real number (ℝ)

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.962672

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	488.8 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	15
Q3	22
95-th percentile	27
Maximum	31
Range	30
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	8.3223813
Coefficient of variation (CV)	0.55620956
Kurtosis	-1.0662622
Mean	14.962672
Median Absolute Deviation (MAD)	7
Skewness	0.05465845
Sum	935975
Variance	69.262031
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
15	2451	3.9%
17	2451	3.9%
9	2414	3.9%
24	2389	3.8%
22	2384	3.8%
14	2380	3.8%
10	2367	3.8%
7	2364	3.8%
11	2353	3.8%
2	2333	3.7%
Other values (19)	38668	61.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1969	3.1%
2	2333	3.7%
3	2255	3.6%
4	1874	3.0%
5	2078	3.3%
6	1957	3.1%
7	2364	3.8%
8	1917	3.1%
9	2414	3.9%
10	2367	3.8%

Value	Count	Frequency (%)
31	1700	2.7%
30	1247	2.0%
27	2153	3.4%
26	2217	3.5%
25	2303	3.7%
24	2389	3.8%
23	2237	3.6%
22	2384	3.8%
21	2268	3.6%
20	2011	3.2%

day_of_week
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0094958

Minimum	0
Maximum	6
Zeros	8712
Zeros (%)	13.9%
Negative	0
Negative (%)	0.0%
Memory size	488.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.9894465
Coefficient of variation (CV)	0.66105642
Kurtosis	-1.2255216
Mean	3.0094958
Median Absolute Deviation (MAD)	2
Skewness	0.0048425372
Sum	188256
Variance	3.9578975
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	9462	15.1%
2	9141	14.6%
6	9124	14.6%
4	8847	14.1%
1	8721	13.9%
0	8712	13.9%
5	8547	13.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8712	13.9%
1	8721	13.9%
2	9141	14.6%
3	9462	15.1%
4	8847	14.1%
5	8547	13.7%
6	9124	14.6%

Value	Count	Frequency (%)
6	9124	14.6%
5	8547	13.7%
4	8847	14.1%
3	9462	15.1%
2	9141	14.6%
1	8721	13.9%
0	8712	13.9%

day_name
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	488.8 KiB

Thursday	9462
Wednesday	9141
Sunday	9124
Friday	8847
Tuesday	8721
Other values (2)	17259

Length

Max length	9
Median length	8
Mean length	7.1535953
Min length	6

Characters and Unicode

Total characters	447486
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Sunday
2nd row	Sunday
3rd row	Sunday
4th row	Sunday
5th row	Sunday

Common Values

Value	Count	Frequency (%)
Thursday	9462	15.1%
Wednesday	9141	14.6%
Sunday	9124	14.6%
Friday	8847	14.1%
Tuesday	8721	13.9%
Monday	8712	13.9%
Saturday	8547	13.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
thursday	9462	15.1%
wednesday	9141	14.6%
sunday	9124	14.6%
friday	8847	14.1%
tuesday	8721	13.9%
monday	8712	13.9%
saturday	8547	13.7%

Most occurring characters

Value	Count	Frequency (%)
d	71695	16.0%
a	71101	15.9%
y	62554	14.0%
u	35854	8.0%
s	27324	6.1%
e	27003	6.0%
n	26977	6.0%
r	26856	6.0%
T	18183	4.1%
S	17671	3.9%
Other values (7)	62268	13.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	384932	86.0%
Uppercase Letter	62554	14.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
d	71695	18.6%
a	71101	18.5%
y	62554	16.3%
u	35854	9.3%
s	27324	7.1%
e	27003	7.0%
n	26977	7.0%
r	26856	7.0%
h	9462	2.5%
i	8847	2.3%
Other values (2)	17259	4.5%

Uppercase Letter

Value	Count	Frequency (%)
T	18183	29.1%
S	17671	28.2%
W	9141	14.6%
F	8847	14.1%
M	8712	13.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	447486	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
d	71695	16.0%
a	71101	15.9%
y	62554	14.0%
u	35854	8.0%
s	27324	6.1%
e	27003	6.0%
n	26977	6.0%
r	26856	6.0%
T	18183	4.1%
S	17671	3.9%
Other values (7)	62268	13.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	447486	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
d	71695	16.0%
a	71101	15.9%
y	62554	14.0%
u	35854	8.0%
s	27324	6.1%
e	27003	6.0%
n	26977	6.0%
r	26856	6.0%
T	18183	4.1%
S	17671	3.9%
Other values (7)	62268	13.9%

hour
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.846037

Minimum	0
Maximum	23
Zeros	1368
Zeros (%)	2.2%
Negative	0
Negative (%)	0.0%
Memory size	488.8 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	8
median	13
Q3	18
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	6.2670396
Coefficient of variation (CV)	0.48785782
Kurtosis	-0.89760046
Mean	12.846037
Median Absolute Deviation (MAD)	5
Skewness	-0.23922809
Sum	803571
Variance	39.275785
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
13	3319	5.3%
18	3265	5.2%
14	3252	5.2%
12	3223	5.2%
11	3217	5.1%
19	3204	5.1%
15	3202	5.1%
20	3117	5.0%
10	3097	5.0%
9	3062	4.9%
Other values (14)	30596	48.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1368	2.2%
1	1628	2.6%
2	1632	2.6%
3	1422	2.3%
4	1445	2.3%
5	1485	2.4%
6	1926	3.1%
7	2572	4.1%
8	3013	4.8%
9	3062	4.9%

Value	Count	Frequency (%)
23	2306	3.7%
22	2734	4.4%
21	3001	4.8%
20	3117	5.0%
19	3204	5.1%
18	3265	5.2%
17	3031	4.8%
16	3033	4.8%
15	3202	5.1%
14	3252	5.2%

meridiem
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	488.8 KiB

PM	36687
AM	25867

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	125108
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AM
2nd row	AM
3rd row	AM
4th row	AM
5th row	AM

Common Values

Value	Count	Frequency (%)
PM	36687	58.6%
AM	25867	41.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pm	36687	58.6%
am	25867	41.4%

Most occurring characters

Value	Count	Frequency (%)
M	62554	50.0%
P	36687	29.3%
A	25867	20.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	125108	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
M	62554	50.0%
P	36687	29.3%
A	25867	20.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	125108	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	62554	50.0%
P	36687	29.3%
A	25867	20.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	125108	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	62554	50.0%
P	36687	29.3%
A	25867	20.7%

is_weekend
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	61.2 KiB

False	44883
True	17671

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	44883	71.8%
True	17671	28.2%

user_id
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	488.8 KiB

user11	37961
user12	24593

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	375324
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	user11
2nd row	user11
3rd row	user11
4th row	user11
5th row	user11

Common Values

Value	Count	Frequency (%)
user11	37961	60.7%
user12	24593	39.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
user11	37961	60.7%
user12	24593	39.3%

Most occurring characters

Value	Count	Frequency (%)
1	100515	26.8%
u	62554	16.7%
s	62554	16.7%
e	62554	16.7%
r	62554	16.7%
2	24593	6.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	250216	66.7%
Decimal Number	125108	33.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	62554	25.0%
s	62554	25.0%
e	62554	25.0%
r	62554	25.0%

Decimal Number

Value	Count	Frequency (%)
1	100515	80.3%
2	24593	19.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	250216	66.7%
Common	125108	33.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	62554	25.0%
s	62554	25.0%
e	62554	25.0%
r	62554	25.0%

Common

Value	Count	Frequency (%)
1	100515	80.3%
2	24593	19.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	375324	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	100515	26.8%
u	62554	16.7%
s	62554	16.7%
e	62554	16.7%
r	62554	16.7%
2	24593	6.6%

Auto

Heatmap
Table

	actionOption	actionSubOption	emotionPositive	emotionTension	activity	day	day_of_week	hour	action	actionSub	condition	conditionSub1Option	conditionSub2Option	place	date_ymd	month	day_name	meridiem	is_weekend	user_id
actionOption	1.000	-0.424	-0.015	-0.019	0.088	0.005	0.012	0.231	1.000	1.000	0.616	0.472	0.193	0.536	0.231	0.099	0.192	0.339	0.366	0.262
actionSubOption	-0.424	1.000	-0.051	0.174	-0.037	-0.047	-0.137	-0.059	0.665	0.665	0.496	0.167	0.516	0.352	0.366	0.192	0.228	0.316	0.480	0.515
emotionPositive	-0.015	-0.051	1.000	-0.309	-0.031	0.005	0.239	0.201	0.287	0.272	0.322	0.323	0.363	0.278	0.355	0.069	0.174	0.234	0.311	0.590
emotionTension	-0.019	0.174	-0.309	1.000	-0.018	0.066	-0.054	-0.044	0.312	0.243	0.390	0.363	0.408	0.344	0.281	0.143	0.140	0.077	0.197	0.596
activity	0.088	-0.037	-0.031	-0.018	1.000	0.013	-0.051	0.023	0.273	0.532	0.111	0.128	0.124	0.297	0.092	0.022	0.050	0.129	0.103	0.071
day	0.005	-0.047	0.005	0.066	0.013	1.000	0.135	-0.029	0.153	0.143	0.256	0.334	0.341	0.233	1.000	1.000	0.485	0.061	0.694	0.108
day_of_week	0.012	-0.137	0.239	-0.054	-0.051	0.135	1.000	0.023	0.187	0.141	0.329	0.391	0.147	0.252	1.000	0.360	1.000	0.061	1.000	0.049
hour	0.231	-0.059	0.201	-0.044	0.023	-0.029	0.023	1.000	0.353	0.625	0.397	0.323	0.231	0.375	0.064	0.046	0.045	1.000	0.068	0.336
action	1.000	0.665	0.287	0.312	0.273	0.153	0.187	0.353	1.000	1.000	0.665	0.636	0.329	0.714	0.196	0.167	0.187	0.490	0.387	0.347
actionSub	1.000	0.665	0.272	0.243	0.532	0.143	0.141	0.625	1.000	1.000	0.530	0.301	0.125	0.994	0.195	0.011	0.141	0.316	0.127	0.098
condition	0.616	0.496	0.322	0.390	0.111	0.256	0.329	0.397	0.665	0.530	1.000	0.633	0.116	0.774	0.407	0.125	0.329	0.183	0.453	0.119
conditionSub1Option	0.472	0.167	0.323	0.363	0.128	0.334	0.391	0.323	0.636	0.301	0.633	1.000	0.137	0.587	0.512	0.193	0.391	0.166	0.750	0.209
conditionSub2Option	0.193	0.516	0.363	0.408	0.124	0.341	0.147	0.231	0.329	0.125	0.116	0.137	1.000	0.280	0.490	0.080	0.147	0.105	0.109	0.745
place	0.536	0.352	0.278	0.344	0.297	0.233	0.252	0.375	0.714	0.994	0.774	0.587	0.280	1.000	0.361	0.218	0.252	0.229	0.485	0.251
date_ymd	0.231	0.366	0.355	0.281	0.092	1.000	1.000	0.064	0.196	0.195	0.407	0.512	0.490	0.361	1.000	1.000	1.000	0.109	1.000	0.133
month	0.099	0.192	0.069	0.143	0.022	1.000	0.360	0.046	0.167	0.011	0.125	0.193	0.080	0.218	1.000	1.000	0.360	0.000	0.069	0.099
day_name	0.192	0.228	0.174	0.140	0.050	0.485	1.000	0.045	0.187	0.141	0.329	0.391	0.147	0.252	1.000	0.360	1.000	0.061	1.000	0.049
meridiem	0.339	0.316	0.234	0.077	0.129	0.061	0.061	1.000	0.490	0.316	0.183	0.166	0.105	0.229	0.109	0.000	0.061	1.000	0.050	0.170
is_weekend	0.366	0.480	0.311	0.197	0.103	0.694	1.000	0.068	0.387	0.127	0.453	0.750	0.109	0.485	1.000	0.069	1.000	0.050	1.000	0.031
user_id	0.262	0.515	0.590	0.596	0.071	0.108	0.049	0.336	0.347	0.098	0.119	0.209	0.745	0.251	0.133	0.099	0.049	0.170	0.031	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	action	actionOption	actionSub	actionSubOption	condition	conditionSub1Option	conditionSub2Option	place	emotionPositive	emotionTension	activity	dt_kst	date_ymd	year	month	day	day_of_week	day_name	meridiem	is_weekend	user_id
0	sleep	111	NaN	NaN	WITH_ONE	2.0	1.0	other_indoor	4	2	3	2020-08-30 00:00:00+09:00	2020-08-30	2020	8	30	6	Sunday	AM	True	user11
1	sleep	111	NaN	NaN	WITH_ONE	2.0	1.0	other_indoor	4	2	3	2020-08-30 00:01:00+09:00	2020-08-30	2020	8	30	6	Sunday	AM	True	user11
2	sleep	111	NaN	NaN	WITH_ONE	2.0	1.0	other_indoor	4	2	3	2020-08-30 00:02:00+09:00	2020-08-30	2020	8	30	6	Sunday	AM	True	user11
3	sleep	111	NaN	NaN	WITH_ONE	2.0	1.0	other_indoor	4	2	3	2020-08-30 00:03:00+09:00	2020-08-30	2020	8	30	6	Sunday	AM	True	user11
4	sleep	111	NaN	NaN	WITH_ONE	2.0	1.0	other_indoor	4	2	3	2020-08-30 00:04:00+09:00	2020-08-30	2020	8	30	6	Sunday	AM	True	user11
5	sleep	111	NaN	NaN	WITH_ONE	2.0	1.0	other_indoor	4	2	3	2020-08-30 00:05:00+09:00	2020-08-30	2020	8	30	6	Sunday	AM	True	user11
6	sleep	111	NaN	NaN	WITH_ONE	2.0	1.0	other_indoor	4	2	3	2020-08-30 00:06:00+09:00	2020-08-30	2020	8	30	6	Sunday	AM	True	user11
7	sleep	111	NaN	NaN	WITH_ONE	2.0	1.0	other_indoor	4	2	3	2020-08-30 00:07:00+09:00	2020-08-30	2020	8	30	6	Sunday	AM	True	user11
8	sleep	111	NaN	NaN	WITH_ONE	2.0	1.0	other_indoor	4	2	3	2020-08-30 00:08:00+09:00	2020-08-30	2020	8	30	6	Sunday	AM	True	user11
9	sleep	111	NaN	NaN	WITH_ONE	2.0	1.0	other_indoor	4	2	3	2020-08-30 00:09:00+09:00	2020-08-30	2020	8	30	6	Sunday	AM	True	user11

	action	actionOption	actionSub	actionSubOption	condition	conditionSub1Option	conditionSub2Option	place	emotionPositive	emotionTension	activity	dt_kst	date_ymd	year	month	day	day_of_week	day_name	hour	meridiem	is_weekend	user_id
62544	sleep	111	NaN	NaN	ALONE	NaN	NaN	home	6	1	3	2020-09-27 23:23:00+09:00	2020-09-27	2020	9	27	6	Sunday	23	PM	True	user12
62545	sleep	111	NaN	NaN	ALONE	NaN	NaN	home	6	1	3	2020-09-27 23:24:00+09:00	2020-09-27	2020	9	27	6	Sunday	23	PM	True	user12
62546	sleep	111	NaN	NaN	ALONE	NaN	NaN	home	6	1	3	2020-09-27 23:25:00+09:00	2020-09-27	2020	9	27	6	Sunday	23	PM	True	user12
62547	sleep	111	NaN	NaN	ALONE	NaN	NaN	home	6	1	3	2020-09-27 23:26:00+09:00	2020-09-27	2020	9	27	6	Sunday	23	PM	True	user12
62548	sleep	111	NaN	NaN	ALONE	NaN	NaN	home	6	1	3	2020-09-27 23:27:00+09:00	2020-09-27	2020	9	27	6	Sunday	23	PM	True	user12
62549	sleep	111	NaN	NaN	ALONE	NaN	NaN	home	6	1	3	2020-09-27 23:28:00+09:00	2020-09-27	2020	9	27	6	Sunday	23	PM	True	user12
62550	sleep	111	NaN	NaN	ALONE	NaN	NaN	home	6	1	3	2020-09-27 23:29:00+09:00	2020-09-27	2020	9	27	6	Sunday	23	PM	True	user12
62551	sleep	111	NaN	NaN	ALONE	NaN	NaN	home	6	1	3	2020-09-27 23:30:00+09:00	2020-09-27	2020	9	27	6	Sunday	23	PM	True	user12
62552	sleep	111	NaN	NaN	ALONE	NaN	NaN	home	6	1	3	2020-09-27 23:31:00+09:00	2020-09-27	2020	9	27	6	Sunday	23	PM	True	user12
62553	sleep	111	NaN	NaN	ALONE	NaN	NaN	home	6	1	3	2020-09-27 23:32:00+09:00	2020-09-27	2020	9	27	6	Sunday	23	PM	True	user12

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category